Company name
Financial Model: Table of Contents
1) PRELIMINARY STATEMENTS - Instructions - Assumptions 2) SUMMARY STATEMENTS - Income Statement - Balance Sheet - Statement of Sources & Uses - Revenue, Gross Margin, & Profit Graph - Breakeven Chart 3) DETAILED FINANCIAL STATEMENTS - Receipts & Disbursements - Statement of Sources & Uses - Income Statement - Balance Sheet 4) SALES PROJECTIONS AND MARGIN ANALYSES - Product One - Product Two - Product Three - Services 5) STAFFING PLAN 6) EQUIPMENT PURCHASES 7) MANUFACTURING & INVENTORY 8) RENT & TAXES 9) FINANCING ACTIVITIES
Page 1 Page 2 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 12 Page 15 Page 21 Page 24 Page 27 Page 30 Page 33 Page 36 Page 42 Page 48 Page 51 Page 54
Version 3.2 (manufacturing)
Company name
Financial Model: Instructions
1) ENTERING INFORMATION INTO THE MODEL: The DETAIL Worksheet. - Enter all inputs & assumptions in either the Assumptions page or the DETAIL worksheet. - Inputs are shaded yellow and appear blue when entered. - All other cells are protected and their formulas cannot be altered or seen without unprotecting the sheet. - At the top of the worksheet are three check lines. Values in each of these cells should always equal zero. - For information on the principles of financial projections, please contact a Coopers & Lybrand Emerging Company Services Consultant. 2) VIEWING THE RESULTS: The Assumptions Page, Summary Statements, and Revenue Growth and Breakeven Charts. - Click on the Assumptions tab to view all inputs and underlying assumptions for the financial model. - Click on the Summary Statements tab to view the annual Income Statement, Balance Sheet, and Statement of Sources & Uses for each of the five years projected. - At the top of the Summary Statements sheet are three check lines similar to those in the DETAIL worksheet. These should equal zero at all times as well. - Click on the Revenue Growth Chart tab to view the growth in revenues over the fiveyear projection period. - Click on the Breakeven Chart tab to view the cash flow breakeven point. - Data for the Assumptions page and Financial Charts are drawn automatically from the DETAIL worksheet. You do not need to add anything more to these sheets. 3) CUSTOMIZING THE FINANCIAL MODEL - To view the formula cells, choose Protection from the TOOLS menu and select Unprotect Worksheet. To protect the sheet again, choose Protection and select Protect Worksheet. - The variable inputs in the DETAIL worksheet are designed to accomodate most business models; however, the financial model can be tailored to suit specific business needs or operating procedures. - Structural changes to the model, such as additional product lines, extra departments, or embedded sales forecasts, require modifications of the underlying formulas. To make such changes, please contact an ECS Consultant. 4) PRINTING THE FINANCIAL STATEMENTS - To print the entire model, choose Print from the FILE menu and select "Entire Workbook". Click OK. - To print an individual worksheet (such as the Assumptions sheet only) click on the tab of the sheet you would like to print, choose Print from the FILE menu, and select "Selected Sheet". Click OK.
Page 1
Company name
Fin an cial Mo d el: A ssu m p tio n s
SALES
UNITS SALES Product One Product Two Product Three Services
2005 -
2006 -
2007 -
2008 -
2009 -
AVERAGE UNIT PRICE Product One Product Two Product Three Services
2005 -
2006 -
2007 -
2008 -
2009 -
COST OF GOODS
AVERAGE UNIT COST Product One Product Two Product Three Services
2005 -
2006 -
2007 -
2008 -
2009 -
Returns.................................................................................................................................................................................................." 0% (as a percentage of Product One revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Product Two revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Product Three revenue).................................................................................................................................................................................... Returns.................................................................................................................................................................................................." 0% (as a percentage of Services revenue)....................................................................................................................................................................................
BALANCE SHEET
Accounts Receivable (adjustable up to 360 days)................................................................................................................................................................................................................ 60 days (in days)................................................................................................................................................................................................................ Accounts Payable (fixed at 30 days)..................................................................................................................................................................................................................... 30 days (in days)..................................................................................................................................................................................................................... Salaries Payable (fixed at 15 days)............................................................................................................................................................................................................................ 15 days (in days)............................................................................................................................................................................................................................ Taxes Payable (fixed at 90 days)............................................................................................................................................................................................................................. 90 days (in days)............................................................................................................................................................................................................................. Inventory (adjustable up to 360 days).......................................................................................................................................................................................................................... 0 days (in days).......................................................................................................................................................................................................................... Available Credit Line......................................................................................................................................................................................................................................... 0% (as a percentage of net accounts receivable)................................................................................................................................................................................................ Maximum Credit Line Used..................................................................................................................................................................................................................................... $0 (amount borrowed not to exceed)................................................................................................................................................................................................... Capital Equipment Lease Term (1 year minimum).............................................................................................................................................................................................................. 3 years (in years).............................................................................................................................................................................................................. Long Term Borrowings Term (1 year minimum).............................................................................................................................................................................................................. 5 years (in years)..............................................................................................................................................................................................................
DEPRECIATION Content Engineering Sales & Marketing Administration
Hardware 3 years 3 years 3 years 3 years
Software 3 years 3 years 3 years 3 years
Furn & Fixtures 3 years 3 years 3 years 3 years
Page 2
Company name
Fin an cial Mo d el: A ssu m p tio n s
EXPENSES
HEADCOUNT Content Engineering Sales & Marketing Administration TOTAL
2005 -
2006 -
2007 -
2008 -
2009 -
PER PERSON EXPENSES Content Engineering Sales & Marketing Administration
Supplies 100 100 100 100
Travel & Meals 500 500 2,500 1,000
Phone/Postage 100 100 300 250
EQUIPMENT PURCHASES Content Engineering Sales & Marketing Administration
Hardware 3,000 3,500 2,500 1,500
Software 1,500 1,500 1,000 1,000
Furn & Fixtures 1,000 1,000 1,000 1,000
Benefits & Taxes....................................................................................................................................................................................... 25% (as a percentage of salaries)....................................................................................................................................................................................... Salary Increases.................................................................................................................................................................................................. 5% (as an annual percentage).................................................................................................................................................................................................. Sales Commissions..................................................................................................................................................................................................... 100% (as a percentage of sales)..................................................................................................................................................................................................... Total Sales Through Commissions................................................................................................................................................... 10% (as a percentage of total revenue)................................................................................................................................................... Business Insurance.................................................................................................................................................................................................. 1% (as a percentage of total revenue)................................................................................................................................................................................................... Anticipated Bad Debt................................................................................................................................................................................................... 1% (as a percentage of collections)........................................................................................................................................................................................................ Interest Revenue........................................................................................................................................................................................................................... 4% (as a percentage of cash balance)....................................................................................................................................................................................................... Interest Expense On Credit Line.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Interest Expense On Capital Equipment Lease.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Interest Expense On Long Term Borrowings.................................................................................................................................................................................................... 10% (as a percentage of outstanding balance)...................................................................................................................................................................................................... Combined Federal & State Tax Rate................................................................................................................................................................................. 40% (as a percentage of positive cumulative income)................................................................................................................................................... Office Rent................................................................................................................................................................................................................ $1.50 (per square foot)....................................................................................................................................................................................................... Minimum Office Space...................................................................................................................................................................................................................... 250 sq ft (square footage per person)....................................................................................................................................................................................................... Term of Office Lease...................................................................................................................................................................................................................... 12 mos (in months)....................................................................................................................................................................................................... Utilities Expense........................................................................................................................................................................................................... $0.15 (per square foot)....................................................................................................................................................................................................... Maintanence Expense................................................................................................................................................................................................ $0.10 (per square foot).......................................................................................................................................................................................................
Page 3
RECEIPTS & DISBURSEMENTS Company name
14-Aug-08 2:34 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Month 1 Jan-05 0 Month 2 Feb-05 0 Month 3 Mar-05 0 Month 4 Apr-05 0 Month 5 May-05 0 Month 6 Jun-05 0 Month 7 Jul-05 0 Month 8 Aug-05 0 Month 9 Sep-05 0 Month 10 Oct-05 0 Month 11 Nov-05 0 Month 12 Dec-05 0 Total 2005 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 9
RECEIPTS & DISBURSEMENTS Company name
14-Aug-08 2:34 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Month 13 Jan-06 0 Month 14 Feb-06 0 Month 15 Mar-06 0 Month 16 Apr-06 0 Month 17 May-06 0 Month 18 Jun-06 0 Month 19 Jul-06 0 Month 20 Aug-06 0 Month 21 Sep-06 0 Month 22 Oct-06 0 Month 23 Nov-06 0 Month 24 Dec-06 0 Total 2006 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 10
RECEIPTS & DISBURSEMENTS Company name
14-Aug-08 2:34 PM BEGINNING CASH Receipts Collections Financings Borrowings Interest Revenue Total receipts Disbursements Salaries Benefits & Empl Taxes Incentives/commissions Direct Material Returns Advertising Promotional Material Trade Shows Supplies/Materials Travel & Meals Telephone/Postage Maintenance & Repair Rent Utilities Insurance Consultants Professional Services Taxes Equipment Purchases Debt Repayments Interest Expense Prior Accounts Payable Total Disbursements Changes in Cash ENDING CASH Total 2007 0 Total 2008 0 Total 2009 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Page 11
STATEMENT OF SOURCES AND USES Company name
14-Aug-08 2:34 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Month 1 Jan-05 0 Month 2 Feb-05 0 Month 3 Mar-05 0 Month 4 Apr-05 0 Month 5 May-05 0 Month 6 Jun-05 0 Month 7 Jul-05 0 Month 8 Aug-05 0 Month 9 Sep-05 0 Month 10 Oct-05 0 Month 11 Nov-05 0 Month 12 Dec-05 0 Total 2005 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 12
STATEMENT OF SOURCES AND USES Company name
14-Aug-08 2:34 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Month 13 Jan-06 0 Month 14 Feb-06 0 Month 15 Mar-06 0 Month 16 Apr-06 0 Month 17 May-06 0 Month 18 Jun-06 0 Month 19 Jul-06 0 Month 20 Aug-06 0 Month 21 Sep-06 0 Month 22 Oct-06 0 Month 23 Nov-06 0 Month 24 Dec-06 0 Total 2006 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 13
STATEMENT OF SOURCES AND USES Company name
14-Aug-08 2:34 PM BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Buyback of Preferred Stock Buyback of Common Stock Less Changes In: Net Accounts Rec Total 2007 0 Total 2008 0 Total 2009 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0
0 0 0
Page 14
Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
Page 15
Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
Page 16
Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
Page 17
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
Page 18
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
Page 19
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Revenue Product One Product Two Product Three Services Total Revenue Expenses Cost of Goods Sold Direct Labor Other Direct Costs Direct Materials Returns Total COGS Gross Margin % of Sales Operating Expenses ENGINEERING Headcount Salary Incentives Benefits & Taxes Consultants Supplies/ Materials Travel & Meals Telephone/Postage Operations Setup Depreciation Total Expenses % of Sales SALES & MARKETING Headcount Salary Incentives/Commissions Benefits & Taxes Supplies Travel & Meals Telephone/Postage Depreciation Total Expenses % of Sales Total 2007 Total 2008 Total 2009
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0 0%
Page 20
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Adv/Promotion Advertising Trade Shows Collateral Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 21
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Adv/Promotion Advertising Trade Shows Collateral Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 22
INCOME STATEMENT Company name
14-Aug-08 2:34 PM Adv/Promotion Advertising Trade Shows Collateral Total 2007 Total 2008 Total 2009
0 0 0
0 0 0
0 0 0
Page 23
Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
Page 24
Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
Page 25
Total Adv/Promotion % of Sales ADMINISTRATION Headcount Salary Incentives Benefits & Taxes Office Supplies Travel & Meals Telephone/Postage Insurance Professional Services Bad Debt Office Rent Utilities Maint/Repair Depreciation Total Expenses % of Sales Total Operating Exp % of Sales Income Before Int & Taxes % of Sales Interest Interest Revenue (4% of cash) Interest Expense (10% of Credit Line) Interest Expense - (10% of Cap. Equip. Lease) Interest Expense - (10% of Long Term Debt) Net Interest Revenue Income Before Taxes Tax Exp Net Income % of Sales
0 0%
0 0%
0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0% 0 0% 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
0 0 0 0 0 0 0 0 0%
Page 26
BALANCE SHEET Company name
14-Aug-08 2:34 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 27
BALANCE SHEET Company name
14-Aug-08 2:34 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 28
BALANCE SHEET Company name
14-Aug-08 2:34 PM ASSETS Current Assets Cash Gross Accounts Receivable (60 days) Allow for Doubtful Accts (1%) Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Computer Hardware Computer Software Furniture & Fixtures Total Gross Fixed Assets Accumulated Depreciation Computer Hardware Computer Software Furniture & Fixtures Total Accum Deprec Net Fixed Assets Total 2007 Total 2008 Total 2009
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 29
TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 30
TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 31
TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Current Portion of Long Term Debt Total ST Liabs Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total LT Liabs TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY
0
0
0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 32
SALES PROJECTIONS & MARGIN ANALYSIS Product One
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 33
SALES PROJECTIONS & MARGIN ANALYSIS Product One
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 34
SALES PROJECTIONS & MARGIN ANALYSIS Product One
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Total 2007 Total 2008 Total 2009
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 35
SALES PROJECTIONS & MARGIN ANALYSIS
Page 36
SALES PROJECTIONS & MARGIN ANALYSIS
Page 37
SALES PROJECTIONS & MARGIN ANALYSIS
Page 38
Product Two
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 39
Product Two
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 40
Product Two
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Total 2007 Total 2008 Total 2009
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0.0%
Page 41
SALES PROJECTIONS & MARGIN ANALYSIS Product Three
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 42
SALES PROJECTIONS & MARGIN ANALYSIS Product Three
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
Page 43
SALES PROJECTIONS & MARGIN ANALYSIS Product Three
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Total 2007 Total 2008 Total 2009
0 0 0
0 0 0
0 0 0
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0
0 0 0
0 0 0
Page 44
Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
Page 45
Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
Page 46
Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
Page 47
SALES PROJECTIONS & MARGIN ANALYSIS Services
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
Page 48
SALES PROJECTIONS & MARGIN ANALYSIS Services
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
Page 49
SALES PROJECTIONS & MARGIN ANALYSIS Services
14-Aug-08 2:34 PM Units s.k.u. 1 s.k.u. 2 Total Units Price s.k.u. 1 s.k.u. 2 Revenue s.k.u. 1 s.k.u. 2 Total Revenue Proportion of Total Revenues COGS Unit Cost s.k.u. 1 s.k.u. 2 Direct Materials Cost s.k.u. 1 s.k.u. 2 Total Direct Materials Labor Other Direct Costs Returns (0% of product revenue) Total COGS GROSS MARGIN Gross Margin % of Sales Total 2007 Total 2008 Total 2009
0 0 0
0 0 0
0 0 0
1.00 0.00
1.00 0.00
1.00 0.00
0 0 0 0.0%
0 0 0 0.0%
0 0 0 0.0%
0.00 0.00
0.00 0.00
0.00 0.00
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
0 0 0 0 0 0 0 0 0.0%
Page 50
STAFFING PLAN Company name
14-Aug-08 2:34 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Month 1 Jan-05 Month 2 Feb-05 Month 3 Mar-05 Month 4 Apr-05 Month 5 May-05 Month 6 Jun-05 Month 7 Jul-05 Month 8 Aug-05 Month 9 Sep-05 Month 10 Oct-05 Month 11 Nov-05 Month 12 Dec-05 Total 2005
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 51
STAFFING PLAN Company name
14-Aug-08 2:34 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Month 13 Jan-06 Month 14 Feb-06 Month 15 Mar-06 Month 16 Apr-06 Month 17 May-06 Month 18 Jun-06 Month 19 Jul-06 Month 20 Aug-06 Month 21 Sep-06 Month 22 Oct-06 Month 23 Nov-06 Month 24 Dec-06 Total 2006
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 52
STAFFING PLAN Company name
14-Aug-08 2:34 PM Content Senior Application Engineer Inventory Technical Support Mgr. Technical Support Tech. Support Assistant Total Staff Engineering CTO System Administration Project Manager Programming Quality Assurance Total 2007 Total 2008 Total 2009
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
Page 53
Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
Page 54
Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Admin. Assistant
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
Page 55
Total Staff Sales & Marketing VP Marketing Mktg. Manager VP Sales Sales Representative Sales Engineer VP Business Development Customer Support Mktg. Assistant Total Staff Administration CEO CFO COO HR Manager Office Manager Admin. Assistant
0
0
0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
Page 56
Company name
Income Statement ($) 2005 Revenue Product One Product Two Product Three Services Total Revenue Cost of Goods Sold Gross Margin % of Revenue Operating Expenses Engineering % of Revenue Marketing/Sales % of Revenue Administration % of Revenue Total Operating Expenses % of Revenue Income Before Int & Taxes % of Revenue Interest Expense Interest Revenue Income Before Taxes Tax Exp Net Income % of Revenue 2006 2007 2008 2009
$0 $0 $0 $0 $0 $0 $0 0%
$0 $0 $0 $0 $0 $0 $0 0%
$0 $0 $0 $0 $0 $0 $0 0%
$0 $0 $0 $0 $0 $0 $0 0%
$0 $0 $0 $0 $0 $0 $0 0%
$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%
$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%
$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%
$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%
$0 0% $0 0% $0 0% $0 0% $0 0% $0 $0 $0 $0 $0 0%
Page 4
Company name
Balance Sheet ($) 2005 ASSETS Current Assets Cash Net Accounts Rec Inventory (0 days) Total Current Assets Gross Fixed Assets Less Accum Depreciation Net Fixed Assets TOTAL ASSETS LIABILITIES Short Term Liabilities Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Line of Credit (0% of net A/R) Current Portion of Capital Equipment Lease Current Portion of Long Term Debt Total Short Term Liabilities Long Term Liabilities Capital Equipment Lease (3 years) Long Term Debt (5 years) Total Long Term Liabilities TOTAL LIABILITIES Equity Preferred Stock Common Stock Retained Earnings Total Equity LIABILITIES & EQUITY 2006 2007 2008 2009
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
$0 $0 $0 $0 $0
Page 5
Company name
Statement of Sources & Uses ($) 2005 BEGINNING CASH Sources of Cash Net Income Add Depr/Amort Issuance of Preferred Stock Issuance of Common Stock Plus Changes In: Accounts Payable (30 days) Salaries Payable (15 days) Taxes Payable (90 days) Additions to Line of Credit (0% of net A/R) Additions to Capital Equipment Lease (3 years) Additions to Long Term Debt (5 years) Total Sources of Cash Uses of Cash Less Changes In: Net Accounts Rec Inventory (0 days) Gross Fixed Assets Reductions To Credit Line Reductions To Capital Equipment Lease Reductions To Long Term Debt Total Uses CHANGES IN CASH ENDING CASH $0 2006 $0 2007 $0 2008 $0 2009 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0
Page 6
Forecasted Revenue, Gross Margin, & Income
$MM
2005
2006
Revenue
2007
Gross Margin Net Income
2008
2009
Page 7
Cash Flow Breakeven
100
$ (000s) Jan-05
Apr-05
Jul-05
Oct-05
Receipts
Jan-06
Apr-06
Jul-06
Oct-06
Disbursements
Page 8
41cbaf38-7da8-4146-a10c-701906e8ade9.xls
Revenue Growth 2005 Revenue Gross Margin Net Income 2006 2007 2008 2009
Cash Flow Breakeven ##### ##### ##### ##### ##### ##### Jul-05 ##### ##### ##### ##### ##### Receipts Disbursements
Page 9
41cbaf38-7da8-4146-a10c-701906e8ade9.xls
##### ##### ##### ##### ##### ##### Jul-06 ##### ##### ##### ##### #####
Page 10